CREATE TABLE [dbo].[ProcessEngineType]
(
[ProcessEngineTypeKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ProcessEngineType_ProcessEngineTypeKey] DEFAULT (newid()),
[Name] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ProcessEngineType_Name] DEFAULT (''),
[Assembly] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ProcessEngineType_Assembly] DEFAULT (''),
[QualifiedName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ProcessEngineType_QualifiedName] DEFAULT (''),
[HasTemplate] [bit] NOT NULL,
[HasDesigner] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ProcessEngineType] ADD CONSTRAINT [PK_ProcessEngineType] PRIMARY KEY CLUSTERED ([ProcessEngineTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ProcessEngineType] ADD CONSTRAINT [AK_ProcessEngineType_Name] UNIQUE NONCLUSTERED ([Name]) ON [PRIMARY]
GO